import matplotlib.pyplot as plt
import pandas as pd
df = pd.read_excel('产品销售表.xlsx',sheet_name=['第一分店','第二分店','第三分店'])
df_list = []
df_list.append(df['第一分店'])
df_list.append(df['第二分店'])
df_list.append(df['第三分店'])
width = 0.3
for i in range(len(df_list)):
    df_temp = df_list[i]
    df_temp.drop_duplicates(inplace=True)
    df_temp = df_temp.groupby('季度').agg('sum')
    x = df_temp.index
    height = df_temp['销售额（万元）']
    plt.bar(x + width * i, height, width)



